I just started using oracle and I'm having difficulties switching functions in php from mysql to oracle. Can someone translate the following code into something that will work for oracle.

$sql = "Select * from table";
$resultID = mysql_query($sql);
while( list($row1data,$row2data) = mysql_fetch_row($resultID) )
{
echo $row1data,$row2data; //or whatever
}

Thanks in advance!

would something like this work...

<?php
ociplogon($user,$pass,$host);

$sql = "Select * from table";
ora_parse($cursor,$sql);
ora_exec($cursor);
while( list($row1data, $row2data) = ora_fetch($cursor))
{
echo "row1: " . $row1data . " row2: " . $row2data . "<br>\n";
}
?>

Thanks in advance!